create external table if not exists jms_dm.dm_leave_message_keywords_detail_dt(
    waybill_no                string comment '运单号'
    , update_time             string comment '更新时间'
    , ordersource_code        string comment '订单来源CODE'
    , ordersource_name        string comment '订单来源'
    , register_network_code   string comment '登记网点代码'
    , register_network_name   string comment '登记网点名称'
    , message_keywords        string comment '关键词'
)comment '留言信息关键词明细'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_leave_message_keywords_detail_dt'
tblproperties (
  'discover.partitions'='false',
  'parquet.column.index.access'='true'
);
